SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Alter Procedure [dbo].[spThemNhanVien]
	@tenNV nvarchar(50),
	@cmnd nvarchar(9),
	@diaChi nvarchar(100),
	@sdt nvarchar(15),
	@ngaySinh datetime,
	@maLoaiNV int,
	@maNH int,
	@ngayLam datetime
As
Begin
	Insert Into NhanVien
	(
		TenNV,
		CMND,
		DiaChi,
		SDT,
		NgaySinh,
		MaLoaiNV,
		MaNH,
		NgayLam
	)
	Values
	(
		@tenNV,
		@cmnd,
		@diaChi,
		@sdt,
		@ngaySinh,
		@maLoaiNV,
		@maNH,
		@ngayLam
	)
End